package com.example.tool.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.tool.bean.business.TqCityDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TqCityMapper extends BaseMapper<TqCityDO> {

    /**
     * 所有中国城市获取
     * @return 所有中国城市
     */
    @Select("SELECT * FROM tqcity WHERE countryEn = 'China' and cityEn = leaderEn")
    List<TqCityDO> getAllChinaCity();
}
